﻿<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="CustomerReport.aspx.vb" Inherits="TermWebApp.Management" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title>TEMPLE VACATION</title>
    <link href="StyleSheet1.css" type="text/css" rel="Stylesheet" />
</head>
<body>
    <form id="form2" runat="server">
    <h1>Customer Sales Report</h1>
        <div id='cssmenu'>
            <ul>
                <li class='active'><a href='http://cis-iis2.temple.edu/Fall2013/3342_tuc34018'><span>
                    Home</span></a></li>
                <li class='has-sub'><a href='Login.aspx'><span>Login</span></a></li>
                <li class='has-sub'><a href="Registration.aspx"><span>Registration</span></a></li>
                <li class='has-sub'><a href="Management.aspx"><span>Management</span></a>
                    <ul> 
                        <li><a href="insertHotel.aspx"><span>New Hotel</span></a></li>
                        <li><a href="insertRoom.aspx"><span>New Room</span></a></li>
                    </ul>
                </li>
            </ul>
        </div>
        <br />
        <asp:GridView ID="customerSales" runat="server" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" AutoGenerateColumns="False" DataKeyNames="LoginID" DataSourceID="CustomerData">
            <AlternatingRowStyle BackColor="#CCCCCC" />
            <Columns>
                <asp:BoundField DataField="LoginID" HeaderText="Login ID" ReadOnly="True" SortExpression="LoginID" />
                <asp:BoundField DataField="FirstName" HeaderText="First Name" SortExpression="FirstName" />
                <asp:BoundField DataField="LastName" HeaderText="Last Name" SortExpression="LastName" />
                <asp:BoundField DataField="Email" HeaderText="E-mail" SortExpression="Email" />
                <asp:BoundField DataField="TotalDollarSales" HeaderText="Total Dollar Sales" SortExpression="TotalDollarSales" DataFormatString="{0:c}" />
            </Columns>
            <FooterStyle BackColor="#CCCCCC" />
            <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
            <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
            <RowStyle HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
            <SortedAscendingCellStyle BackColor="#F1F1F1" />
            <SortedAscendingHeaderStyle BackColor="#808080" />
            <SortedDescendingCellStyle BackColor="#CAC9C9" />
            <SortedDescendingHeaderStyle BackColor="#383838" />
        </asp:GridView>
        <asp:SqlDataSource ID="CustomerData" runat="server" ConnectionString="<%$ ConnectionStrings:SSH_CONNECTIONS_ONLY %>" SelectCommand="SELECT [LoginID], [FirstName], [LastName], [Email], [TotalDollarSales] FROM [Customer_t] ORDER BY [TotalDollarSales] DESC"></asp:SqlDataSource>
    </form>
</body>
</html>
